﻿CREATE TABLE [Businesses].[Businesses]
(
	BusinessID int NOT NULL IDENTITY(1,1), 
	CategoryID int NOT NULL,
	MemberID int NOT NULL,
	StatusID tinyint NOT NULL,
	Name varchar(70) NOT NULL,
	Street varchar(100) NULL,
	Street2 varchar(100) NULL,
	City varchar(50) NULL,
	State varchar(40) NULL,
	Zip varchar(10) NULL,
	Phone varchar(15) NOT NULL,
	[Description] text NOT NULL,
	CreatedOn smalldatetime NOT NULL,
	ExpiresOn smalldatetime NOT NULL
)
